localtime,localtimestamp

localtime,localtimestamp

description

Syntax:

DATETIME localtime() DATETIME localtimestamp()

This function fetches the current time and returns a result in DATETIME type.

Example

mysql> select localtime();
+---------------------+
| localtime()         |
+---------------------+
| 2022-09-22 17:30:23 |
+---------------------+

mysql> select localtimestamp();
+---------------------+
| localtimestamp()    |
+---------------------+
| 2022-09-22 17:30:29 |
+---------------------+

Keywords

localtime,localtimestamp